Data intergrity


python manage.py shell
>>> from exams.models import SchoolDivisionSummary
>>>
>>> SchoolDivisionSummary.objects.all().values(
...     "school__school_code", "year", "exam_type_id"
... ).distinct()
<QuerySet [{'school__school_code': 'S0101\r', 'year': 2022, 'exam_type_id': 2}, {'school__school_code': 'S0101', 'year': 2022, 'exam_type_id': 1}, {'school__school_code': 'S0104\r', 'year': 2022, 'exam_type_id': 2}, {'school__school_code': 'S0104', 'year': 2022, 'exam_type_id': 1}, {'school__school_code': 'S0105', 'year': 2022, 'exam_type_id': 1}, {'school__school_code': 'S0106\r', 'year': 2022, 'exam_type_id': 2}, {'school__school_code': 'S0106', 'year': 2022, 'exam_type_id': 1}, {'school__school_code'


SELECT COUNT(*)
FROM school_subject_grade_summary
WHERE school_code REGEXP '[\r\n]';
